Hệ thống quản lý trường học bằng PHP / MySQLi
1 <?php
2 error_reporting(0);
3 $conn=mysqli_connect('localhost','root','','sms2')or die(mysqli_error("Connection error"));
4 ?>
5 <?php
6 require_once('session1.php');
7 ?>
8 <?php
9 $id = $_GET['id'];
10 $select = "SELECT * FROM
11 studentstable as t, parents as r
12 WHERE
13 t.admission_number = '$id' AND
14 r.admission_number = t.admission_number ";
15 $result = mysqli_fetch_array(mysqli_query($conn,$select));
16 $qry=mysqli_query($conn,$select);
17 if($qry)
18 {
19 while($rec = mysqli_fetch_array($qry)){
20 $sirname = "$rec[sirname]";
21 $firstname = "$rec[firstname]";
22 $lastname = "$rec[lastname]";
23 $idno = "$rec[idno]";
24 $dateofbirth = "$rec[dateofbirth]";
25 $gender = "$rec[gender]";
26 // $country_id = "$rec[country_id]";
27 // $county_id = "$rec[county_id]";
28 // $constituency_id = "$rec[constituency_id]";
29 $mobile = "$rec[mobile]";
30 $email = "$rec[email]";
31 $address = "$rec[address]";
32 $zipcode = "$rec[zipcode]";
33 $course_id = "$rec[course_id]";
34 $border = "$rec[border]";
35 $reg_date = "$rec[reg_date]";
36 //LOAD PARENT DETAILS TOO
37 $psirname = "$rec[psirname]";
38 $pfirstname = "$rec[pfirstname]";
39 $plastname = "$rec[plastname]";
40 $pmobile = "$rec[pmobile]";
41 $prelationship = "$rec[prelationship]"; }
42 }
43 ?>
44
45 <?php
46 include('connect.php');
47 $query="SELECT * FROM course WHERE course_id='$course_id'";
48 $records2=mysqli_query($conn,$db,$query);
49 while($rec=mysqli_fetch_array($records2))
50 {
51 $feepayable = $rec['feepayable'];
52
53 }
54
55
56 ?>
57
58
59
60
61
62 <?php
63 SESSION_START();
64 ?>
65
66 <!DOCTYPE html>
67 <html>
68
69 <head>
70 <meta charset="utf-8">
71 <meta name="viewport" content="width=device-width, initial-scale=1.0">
72 <title>school management system</title>
73 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
74 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
75 <link href="assets/css/loader.css" rel="stylesheet" />
76 <script src="assets/js/canvasjs.min.js"></script>
77 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
78 <script src="assets/js/jquery-3.2.1.js"></script>
79
80
81 <style type="text/css">
82 h4{
83 color:red;
84 }
85 </style>
86 </head>
87
88 <body >
89 <!--end of heading section-->
90 <ul class="nav navbar-right top-nav">
91 <div class="dropdown">
92 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
93 <?php
94 //Check to see if the user is logged in.if not redirect user to the loging page.
95
96 if(isset($_SESSION['fname']))
97 {
98 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
99 }else{
100 echo "<script type='text/javascript'>
101 alert( 'You must Log in to use the system');
102 </script>";
103 echo "<script>
104 window.location = 'index.php'
105 </script>";
106 }
107 ?>
108 <span class="caret"></span></button>
109 <ul class="dropdown-menu">
110 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
111 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
112 <li class="divider"></li>
113 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
114 </ul>
115 </div>
116 </ul>
117 <!--************************************************-->
118 <div style="
119 font-family:Nyala, Arial;
120 text-align: left;
121 background-color: #526F35;
122 padding: 20px;
123 color:white;
124 width: 100%;
125 height: 150px;">
126 <!--This codes to load the image loader-->
127 <div id="loading">
128 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
129 </div>
130 <!--this is the heading section-->
131 <h2>
132 <?php
133 $query=mysqli_query($conn,"select * from companyinfo");
134 $num_rows=mysqli_num_rows($query);
135 while($row=mysqli_fetch_array($query))
136 {
137 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
138 $cname = $row['cname'];
139 $cemail = $row['cemail'];
140 $ccontact = $row['ccontact'];
141 $clocation = $row['clocation'];
142 }?>
143 <?php
144 echo $cname;
145 ?>
146
147 <div style="float:right; font-size:20px;text-align:right;">
148
149 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
150 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
151 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
152
153 </div>
154 </h2>
155 </div>
156 <!--end of heading section-->
157
158 <div>
159 <ul class="nav nav-tabs">
160 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
161 <li class="active"><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
162 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
163 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
164 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
165 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
166 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
167 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
168 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
169 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
170
171 </ul>
172 <div class="tab-content">
173 <div class="tab-pane active" role="tabpanel" id="tab-1">
174
175 <p>
176 <div class="table-responsive" >
177 <!--**************************************************************************************************************************-->
178 <div class="container" style="width:100%">
179
180 <ul class="nav nav-tabs">
181 <li ><a href="students.php">New Student <img src="assets/img/new.png"> </a></li>
182 <li><a href="viewstudentrecord.php">View List<img src="assets/img/view2.png"></a></li>
183 <li class="active"><a href="viewstudentsedit1.php">Edit Student<img src="assets/img/view2.png"></a></li>
184 <li><a href="csvstudents.php">Import/Export Data <img src="assets/img/import.png"></a></li>
185 <li><a href="reports_students.php">Reports </a></li>
186 </ul>
187 <br>
188
189 </div>
190
191 <!--*************************************************************************************************************************-->
192 <div class="container-fluid">
193 <div class="row">
194 <div class="col-lg-6 col-lg-offset-3">
195 <div class="panel panel-primary">
196 <div class="panel-heading">Edit Record</div>
197
198 <!-- /.panel-heading -->
199 <div class="panel-body">
200 <div class="table">
201
202 <form action="update.php" method="POST" enctype="multipart/form-data">
203 <div style="float:left; position:relative">
204 <h4>Personal Details</h4>
205
206 <label>Adm NO:</label>
207 <input type="text" name="admission_number" value="<?php echo $id?>" class="form-control">
208
209 <label>Sir name</label>
210 <input type="text" name="sirname" placeholder="e.g Kimani" value="<?php echo $sirname?>" class="form-control">
211
212 <label>Firstname</label>
213 <input type="text" name="firstname" value="<?php echo $firstname?>" class="form-control">
214
215 <label>Last Name</label>
216 <input type="text" name="lastname" value="<?php echo $lastname?>" class="form-control">
217
218 <label>ID/Passport NO.</label>
219 <input type="text" name="idno" value="<?php echo $idno?>" class="form-control">
220
221 <label>DOB</label>
222 <input type="date" name="dateofbirth" value="<?php echo $dateofbirth?>" class="form-control">
223
224 <label>Gender</label>
225 <select id="gender" name="gender" value="<?php echo $gender?>" class="form-control">
226 <option></option>
227 <?php
228 $query=mysqli_query($conn,"select * from genderset");
229 while($row=mysqli_fetch_array($query))
230 {
231 if($result['gender'] == $row['gendername']){
232 $sel = "selected";
233 }else{
234 $sel = "";
235 }
236 ?>
237 <option value="<?php echo $row['gendername'];?>" <?=$sel?> > <?php echo $row['gendername'];?> </option>
238 <?php
239 } ?>
240 </select>
241
242 <!-- <label>Country</label>
243 <input type="text" name="country_id" value="<?php echo $country_id?>" class="form-control" >
244
245 <label>County</label>
246 <select id="county_id" name="county_id" value="<?php echo $county_id?>" class="form-control">
247 <option></option>
248 <?php
249 $query=mysqli_query($conn,"select * from counties");
250 while($row=mysqli_fetch_array($query))
251 {
252 if($result['county_id'] == $row['county_id']){
253 $sel = "selected";
254 }else{
255 $sel = "";
256 }
257 ?>
258 <option value="<?php echo $row['county_id'];?>" <?=$sel?> > <?php echo $row['countyname'];?> </option>
259 <?php
260 } ?>
261 </select>
262 <label>Constituency</label>
263 <select id="constituency_id" name="constituency_id" value="<?php echo $constituency_id?>" class="form-control">
264 <option></option>
265 <?php
266 $query=mysqli_query($conn,"select * from constituency");
267 while($row=mysqli_fetch_array($query))
268 {
269 if($result['constituency_id'] == $row['constituency_id']){
270 $sel = "selected";
271 }else{
272 $sel = "";
273 }
274 ?>
275 <option value="<?php echo $row['constituency_id'];?>" <?=$sel?> > <?php echo $row['constituencyname'];?> </option>
276 <?php
277 } ?>
278 </select>
279 </div> -->
280 <div style="float:right; position:relative">
281 <h4>Contact Details</h4>
282 <label>Mobile</label>
283 <input type="number" name="mobile" value="<?php echo $mobile?>" class="form-control">
284
285 <label>Email</label>
286 <input type="email" name="email" value="<?php echo $email?>" class="form-control">
287
288 <label>Address</label>
289 <input type="text" name="address" value="<?php echo $address?>" class="form-control">
290
291 <label>Zip Code</label>
292 <input type="text" name="zipcode" value="<?php echo $zipcode?>" class="form-control">
293
294 <label>Date of Admission</label>
295 <input type="date" name="reg_date" required value="<?php echo $reg_date; ?>" class="form-control" >
296
297 <label>Course/Class</label>
298 <select id="course_id" name="course_id" value="<?php echo $course_id?>" class="form-control">
299 <option></option>
300 <?php
301 $query=mysqli_query($conn,"select * from course");
302 while($row=mysqli_fetch_array($query))
303 {
304 if($result['course_id'] == $row['course_id']){
305 $sel = "selected";
306 }else{
307 $sel = "";
308 }
309 ?>
310 <option value="<?php echo $row['course_id'];?>" <?=$sel?> > <?php echo $row['coursename'];?> </option>
311 <?php
312 } ?>
313 </select>
314
315
316
317
318 <input type="hidden" id="border" name="border" value="<?php echo $border?>"" class="form-control">
319
320
321 <input type="hidden" name="feepayable" value="<?php echo $feepayable?>" class="form-control">
322
323 </div>
324 <!--this is section three-->
325 <div style="float:left; position:relative; clear:both;">
326 <h4>Guardian/Parent and other Details for student </h4>
327 <!--this are parents details-->
328 <label>Sir name</label>
329 <input type="text" name="psirname" value="<?php echo $psirname?>" class="form-control">
330
331 <label>First name</label>
332 <input type="text" name="pfirstname" value="<?php echo $pfirstname?>" class="form-control">
333
334 <label>Last Name</label>
335 <input type="text" name="plastname" value="<?php echo $plastname?>" class="form-control">
336
337 <label>Mobile</label>
338 <input type="number" name="pmobile" value="<?php echo $pmobile?>" class="form-control">
339
340 <label>Relationship</label>
341 <input type="text" name="prelationship" placeholder="Father" value="<?php echo $prelationship?>" class="form-control"> <br>
342 <input type="submit" name="register" value="Update" class="btn btn-success">
343 <a button type='button' class="btn btn-primary" href="viewstudentrecord.php">Back</a> <br><br>
344 </div>
345 </form>
346 </div>
347 </div>
348 </div>
349 </div>
350 </div>
351 </div>
352
353 <!--*************************************PHP CODES TO SAVE THE DATA************************************************-->
354
355
356 <div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
357 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
358 </div>
359 <script src="assets/js/jquery.min.js"></script>
360 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
361 <script src="assets/js/affix.js"></script>
362 <script src="assets/js/alert.js"></script>
363 <script src="assets/js/alert1.js"></script>
364 <script src="assets/js/bootstrap.js"></script>
365 <script src="assets/js/bootstrap.min.js"></script>
366 <script src="assets/js/bootstrap-datepicker.js"></script>
367 <script src="assets/js/bootstrap-wysihtml5.js"></script>
368 <script src="assets/js/button.js"></script>
369 <script src="assets/js/carousel.js"></script>
370 <script src="assets/js/chosen.jquery.min.js"></script>
371 <script src="assets/js/ckeditor.js"></script>
372 <script src="assets/js/collapse.js"></script>
373 <script src="assets/js/color.js"></script>
374 <script src="assets/js/dropdown.js"></script>
375 <script src="assets/js/DT_bootstrap.js"></script>
376 <script src="assets/js/dynamic.js"></script>
377 <script src="assets/js/ie-emulation-modes-warning.js"></script>
378 <script src="assets/js/jquery.dataTables.js"></script>
379 <script src="assets/js/jquery.dataTables.min.js"></script>
380 <script src="assets/js/jquery.dialog.js"></script>
381 <script src="assets/js/jquery.hoverdir.js"></script>
382 <script src="assets/js/jquery.jgrowl.js"></script>
383 <script src="assets/js/jquery.knob.js"></script>
384 <script src="assets/js/jquery.uniform.min.js"></script>
385 <script src="assets/js/jquery-1.8.3.min.js"></script>
386 <script src="assets/js/jquery-1.9.1.js"></script>
387 <script src="assets/js/jquery-1.9.1.min.js"></script>
388 <script src="assets/js/jquery-1.10.2.js"></script>
389 <script src="assets/js/jquery-1.11.0.js"></script>
390 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
391 <script src="assets/js/jquery-ui-1.10.3.js"></script>
392 <script src="assets/js/modal.js"></script>
393 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
394 <script src="assets/js/myjquery.js"></script>
395 <script src="assets/js/myjquery1.js"></script>
396 <script src="assets/js/npm.js"></script>
397 <script src="assets/js/popover.js"></script>
398 <script src="assets/js/profile.js"></script>
399 <script src="assets/js/raphael-min.js"></script>
400 <script src="assets/js/sb-admin-2.js"></script>
401 <script src="assets/js/scripts.js"></script>
402 <script src="assets/js/scrollspy.js"></script>
403 <script src="assets/js/tab.js"></script>
404 <script src="assets/js/tooltip.js"></script>
405 <script src="assets/js/transition.js"></script>
406 <script src="assets/js/wysihtml5-0.3.0.js"></script>
407 <script language="javascript" type="text/javascript">
408 $(window).load(function()
409 {
410 $('#loading').hide();
411 });
412 </script>
413 </body>
414
415 </html>